在此导入MYSQL数据库,方便大家的网站升级与维护更新,这样很方便操作数据库,同时也非常简单(导入升级数据库,就像上传文件一样简单),不必再那么麻烦要上传一个2M多的PHPmyadmin那么麻烦啦!!!

请上传要导入的mySQL数据库:

如果你是行内人士,可以直接在此手写mysql标准代码,同样可运行,一次写一条:
示例删除一个数据表text:delete from text
如果你想批量删除数据,请复制对应的SQL语句放在上面框内操作.即可(如果有两条语句以上的,请分开一次执行一条)
批量删除用户(示例,删除发贴少于20的会员) delete from lfj_members where postnum<20
删除某个栏目的文章(111代表那个栏目的对应序号) delete from lfj_artic where fid=111
delete from lfj_reply where r_fid=111
删除某位会员的文章('点号不能少,这是英文的标点) delete from lfj_artic where author=[作者]
delete from lfj_reply where r_usr=[作者]

删除N天内的文章(时间计算方法:

{$timestamp}-N天*86400)时间单位是秒

delete from lfj_artic where posttime>1234567890
delete from lfj_reply where r_time>1234567890
删除N天前的文章 delete from lfj_artic where posttime<1234567890
delete from lfj_reply where r_time<1234567890
删除系统消息,以减少空间占用 delete from lfj_msg where username=[公告消息]